create database Students
on
(
	name='Students',
	filename='D:\Students.mdf',
	size=5MB,
	maxsize=100MB,
	filegrowth=5MB

)
log on
(
name='Students_log',
	filename='E:\test\Students_log.mdf',
	size=10MB,
	maxsize=50MB,
	filegrowth=10MB
)
use Students
go

create table Stuinfo
(
	StuID int primary key identity(1,1) not null,
	StuNum varchar(10) not null,
	StuName nvarchar(20) not null,
	StuSex char(2) default('Ů'),
	StuPhone int not null
)
create table Classinfo
(
	ClassID int primary key identity(1,1),
	ClassNum varchar(15) not null,
	ClassName nvarchar(30) not null,
	ClassRemark nchar(200),
	StuID int

)